Embed Link with pivot using filter

Embed Link with pivot using filter: This video contains how to use Embed Link with pivot using filter.

In this Document you will learn to Create a dashboard and add a Card chart widget and Table widget. You will learn create embed link and how to connect embed link with one dashboard to another dashboard and filter detail dashboard with global filter parameters.

[note: to apply global filters, parameterized dataset should be used in detail dashboard]

Docusaurus Slash Introduction

Click on hamburger icon.

Docusaurus Slash Introduction

Click on (+) icon, from visualization Tab.

The Create Dashboard Dialog box will pop up on screen. Enter Dashboard Name as shown in Figure.

Click on Create After entering Dashboard Name in dialog box.

Docusaurus Slash Introduction

You will see an Empty Dashboard, As shown in figure below:

Docusaurus Slash Introduction

From Right Vertical Menu Select the Pivot Widget icon.

The Edit menu box appears as you click on Pivot chart icon. And a widget gets added in content place automatically in dashboard, As shown in Figure below:

Docusaurus Slash Introduction

Enter Following details in Pivot:

Type: Table

Dataset: Salesb.ds

Drag and drop country in rows and productLine in Columns.

Drag and drop country in Values.

Fill above details in edit box, As Shown in figure;

Docusaurus Slash Introduction

Click on Save and Exit.

Pivot widget is shown in Figure Below:

Docusaurus Slash Introduction

Create a New Dashboard and give Name Detailed Data of the dashboard, As shown in figure Below:

Docusaurus Slash Introduction

From Right Vertical Menu Select the Table Widget icon.

The Edit menu box appears as you click on Table Widget icon. And a widget gets added in content place automatically in dashboard, As shown in Figure below:

Docusaurus Slash Introduction

Enter Following details in General Property:

Dataset: Parameter.ds

In Dataset Column Select All the Field.

Fill above details in edit box, As Shown in figure below;

Docusaurus Slash Introduction

Click on Preview and Save and Exit, As shown in figure below:

Docusaurus Slash Introduction

Create a New filter in Detailed 5 dashboard.

Give the Name Country, As shown in figure Below:

Click on Save.

Docusaurus Slash Introduction

In Country filter Event select On Change.

Click on Setting icon of country Filter.

Enter Following details in Filter Widget:

Source: Dataset

Dataset: Salesb.ds

Column Name: Country

Toggle Save Filter and set Default when Clear.

Fill above details, As shown in figure Below:

Docusaurus Slash Introduction

Click on Link Filter and Widget Property.

Enter Following details in Link Filter and Widget Property.

Layer: Layer 1

Tabs: Event Check

Widget: Table Widget 1

Select the country in Available Column.

Fill above details as shown in Figure Below:

Docusaurus Slash Introduction

Click on Save and Exit.

Create another New filter in Detailed 5 dashboard.

Give the Name Product Line of the filter.

In Product Line filter Event select On Change

Click on Setting icon of Product Line Filter.

Enter Following details in Filter Widget:

Source: Dataset

Dataset: Salesb.ds

Column Name: product Line

Toggle Save Filter and set Default when Clear.

Fill above details, As shown in figure Below:

Docusaurus Slash Introduction

Click on Link Filter and Widget Property.

Enter Following details in Link Filter and Widget Property.

Layer: Layer 1

Tabs: Event Check

Widget: Table Widget 1

Select the Product Line in Available Column.

Fill above details as shown in Figure Below:

Docusaurus Slash Introduction

Click on Save and Exit.

Click on Embed icon of the Detailed Data Dashboard, As shown in Figure Below:

Docusaurus Slash Introduction

Copy the Link of Internal Embed in Embed.

Click on Cancel.

Open the Pivot Summery Dashboard 5 in Edit mode.

Enter Following details in Pivot Property:

Hyperlink: Custom Link

Link:

http://localhost:8080/OPNBI/embed/internal/OPNBIHubInternalEmbed/a_i__214&a_n__Detailed5&a_as__dashboards&a_af__true/Country___{{country}}&Product Line___{{productLine}}

Fill above details as shown in figure below:

Click on Preview Save and Exit.

Now Click on Preview mode.

Docusaurus Slash Introduction

Click on Classic car in Column and Canada in Raw.

It will redirect on Detailed Dashboard 5, As shown in figure Below:

Docusaurus Slash Introduction